| Northwind | Test with Yukon |
Category Sales for 1997 View
Owner
dbo
Creation Date
10-07-2003 10:31:36
Remarks
Columns
| Name | Type | Length | IsNullable | Collation |
| CategoryName | nvarchar | 30 |  | SQL_Latin1_General_CP1_CI_AS |
| CategoryName | sysname | 30 | | SQL_Latin1_General_CP1_CI_AS |
| CategorySales | money | 8 |  | |
View Definition
create view "Category Sales for 1997" AS
SELECT "Product Sales for 1997".CategoryName, Sum("Product Sales for 1997".ProductSales) AS CategorySales
FROM "Product Sales for 1997"
GROUP BY "Product Sales for 1997".CategoryName